package com.dingding.service.user.core.sql;

/**
 * 
 * @ClassName: UserCouponSQL 
 * @Description: 用户优惠券SQL
 * @author YHQ
 * @date 2016年6月6日 下午8:34:42
 * 
 */
public class UserCouponSQL {

	//搭车使用优惠券信息
	public static final String GET_COUPON_INFO = "SELECT uc.ucId,uc.couponMoney FROM usercoupon uc INNER JOIN coupon cp ON cp.cpId = uc.couponId AND cp.couponType = 2 WHERE uc.ucId = ? AND uc.couponStatus = 2 ORDER BY uc.couponMoney ASC ";
		
}
